#!/usr/bin/env python 3.9
# -*- coding = utr-8 -*-
'''
@Project: flaskProject
@File: testSQL.py
@IDE: PyCharm
@Author: Simon
@Date: 5/5/21  11:40 PM
'''

import sqlite3

score = []
num = []
con = sqlite3.connect("MeiJu.db")
cur = con.cursor()
sql = "select score,count(score) from MeiJu group by score"
data = cur.execute(sql)
for item in data:
    score.append(item[0])
    # print(item[0])
    num.append(item[1])
    # print(item[1])
cur.close()
con.close()

print(score)
s = list(score.pop(-1))
print(score)

print(type(score))

# for s in score:
#     print(s)

s = [
    6.2,
    6.4,
    6.5,
    6.8,
    6.9,
    7.1,
    7.2,
    7.3,
    7.4,
    7.5,
    7.6,
    7.7,
    7.8,
    7.9,
    8.1,
    8.2,
    8.4,
    8.5,
    8.6,
    8.7,
    8.8,
    8.9,
    9.1,
    9.2
]




# for n in num:
    # print(n)